if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_UpdateCategories]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_UpdateCategories]
GO
CREATE PROC sp_UpdateCategories
	@cateName		nvarchar(200),
	@cateDes		nvarchar(2000),
	@image			varchar(200)
AS
BEGIN
	UPDATE categories
		SET
			CategoryName = @cateName,
			Description = @cateDes,
			[Image] = @image
END